🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-14 🟡

🔹 Automate PDF Data Extraction and Structured Output
👤 Client: 🇺🇸 United States Member since 2023-02-03
💰 Price: $7
🚩 Problem: Manual process for extracting specific fields from multiple PDF documents is inefficient.
📦 Existing: [Stack]

Specifications:

[Target] - Extract data from 9 specific fields in each PDF document.
[Method] - Use VBA to scan input folder, trigger Python script, and handle file movement/rename.
[UI/UX] - Not specified
[Stack] - VBA for macro, Python for extraction, Excel for output format.
[Security] - Ensure data privacy during processing; no external dependencies.
[Format] - Save extracted data in structured Excel format.

Workflow:

1. VBA Macro scans input folder for new PDF files.
2. VBA triggers Python script to open each PDF and extract specified fields.
3. Python returns extracted data to VBA macro.
4. VBA saves extracted data into an Excel file in structured format.
5. VBA renames and moves the processed PDF to output folder.